Setting Exclude Properties

Use the Exclude Name edit box to set the exclude name.

Index Method
The name of the index access method to be used.

Exclude Element(s)
Choose the field(s) to be excluded and specify the operator(s).

Index Tablespace
The tablespace in which to create the index.

Fill Factor
The fillfactor for an index is a percentage that determines how full the index method will try to pack index pages.

Predicate
Specify an exclusion constraint on a subset of the table.

The Comment edit box defines the comment for the exclude.